﻿-- missing icons:
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10001, 'Broadcast Node', '99_06');
UPDATE invTypes SET graphicID = 10001 WHERE typeID = 2867;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10002, 'Integrity Response Drones', '99_02');
UPDATE invTypes SET graphicID = 10002 WHERE typeID = 2868;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10003, 'Nano-Factory', '99_05');
UPDATE invTypes SET graphicID = 10003 WHERE typeID = 2869;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10004, 'Organic Mortar Applicators', '99_03');
UPDATE invTypes SET graphicID = 10004 WHERE typeID = 2870;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10005, 'Recursive Computing Module', '99_07');
UPDATE invTypes SET graphicID = 10005 WHERE typeID = 2871;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10006, 'Self-Harmonizing Power Core', '99_01');
UPDATE invTypes SET graphicID = 10006 WHERE typeID = 2872;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10007, 'Sterile Conduits', '99_04');
UPDATE invTypes SET graphicID = 10007 WHERE typeID = 2875;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10008, 'Wetware Mainframe', '99_08');
UPDATE invTypes SET graphicID = 10008 WHERE typeID = 2876;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10009, 'Bacteria', '97_03');
UPDATE invTypes SET graphicID = 10009 WHERE typeID = 2393;
-- planet icon instead of cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10010, 'Biofuels', '97_06');
UPDATE invTypes SET graphicID = 10010 WHERE typeID = 2396;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10011, 'Chiral Structures', '96_13');
UPDATE invTypes SET graphicID = 10011 WHERE typeID = 2401;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10012, 'Electrolytes', '96_09');
UPDATE invTypes SET graphicID = 10012 WHERE typeID = 2390;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10013, 'Industrial Fibers', '97_07');
UPDATE invTypes SET graphicID = 10013 WHERE typeID = 2397;
-- flipped, missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10014, 'Oxidizing Compound', '96_08');
UPDATE invTypes SET graphicID = 10014 WHERE typeID = 2392;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10015, 'Plasmoids', '96_07');
UPDATE invTypes SET graphicID = 10015 WHERE typeID = 2389;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10016, 'Precious Metals', '96_11');
UPDATE invTypes SET graphicID = 10016 WHERE typeID = 2399;
-- planet icon instead of cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10017, 'Proteins', '97_05');
UPDATE invTypes SET graphicID = 10017 WHERE typeID = 2395;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10018, 'Reactive Metals', '96_10');
UPDATE invTypes SET graphicID = 10018 WHERE typeID = 2398;
-- planet icon instead of cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10019, 'Toxic Metals', '96_12');
UPDATE invTypes SET graphicID = 10019 WHERE typeID = 2400;
-- planet icon instead of cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10020, 'Biocells', '98_12');
UPDATE invTypes SET graphicID = 10020 WHERE typeID = 2329;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10021, 'Microfiber Shielding', '98_13');
UPDATE invTypes SET graphicID = 10021 WHERE typeID = 2327;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10022, 'Oxides', '98_09');
UPDATE invTypes SET graphicID = 10022 WHERE typeID = 2317;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10023, 'Polyaramids', '98_16');
UPDATE invTypes SET graphicID = 10023 WHERE typeID = 2321;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10024, 'Supertensile Plastics', '98_15');
UPDATE invTypes SET graphicID = 10024 WHERE typeID = 2312;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10025, 'Test Cultures', '98_14');
UPDATE invTypes SET graphicID = 10025 WHERE typeID = 2319;
-- flipped, missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10026, 'Water-Cooled CPU', '98_10');
UPDATE invTypes SET graphicID = 10026 WHERE typeID = 2328;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10027, 'Biotech Research Reports', '96_01');
UPDATE invTypes SET graphicID = 10027 WHERE typeID = 2358;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10028, 'Camera Drones', '97_14');
UPDATE invTypes SET graphicID = 10028 WHERE typeID = 2345;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10029, 'Condensates', '97_13');
UPDATE invTypes SET graphicID = 10029 WHERE typeID = 2344;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10030, 'Cryoprotectant Solution', '98_08');
UPDATE invTypes SET graphicID = 10030 WHERE typeID = 2367;
-- offset, missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10031, 'Gel-Matrix Biopaste', '97_16');
UPDATE invTypes SET graphicID = 10031 WHERE typeID = 2348;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10032, 'Hazmat Detection Systems', '98_07');
UPDATE invTypes SET graphicID = 10032 WHERE typeID = 2366;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10033, 'Hermetic Membranes', '98_06');
UPDATE invTypes SET graphicID = 10033 WHERE typeID = 2361;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10034, 'Industrial Explosives', '98_05');
UPDATE invTypes SET graphicID = 10034 WHERE typeID = 2360;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10035, 'Neocoms', '98_04');
UPDATE invTypes SET graphicID = 10035 WHERE typeID = 2354;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10036, 'Nuclear Reactors', '98_03');
UPDATE invTypes SET graphicID = 10036 WHERE typeID = 2352;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10037, 'Smartfab Units', '98_02');
UPDATE invTypes SET graphicID = 10037 WHERE typeID = 2351;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10038, 'Supercomputers', '98_01');
UPDATE invTypes SET graphicID = 10038 WHERE typeID = 2349;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10039, 'Synthetic Synapses', '97_15');
UPDATE invTypes SET graphicID = 10039 WHERE typeID = 2346;
-- missing cargo icon
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10040, 'Ionic Solutions', '96_04');
UPDATE invTypes SET graphicID = 10040 WHERE typeID = 2309;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10041, 'Noble Gas', '96_05');
UPDATE invTypes SET graphicID = 10041 WHERE typeID = 2310;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10042, 'Reactive Gas', '96_06');
UPDATE invTypes SET graphicID = 10042 WHERE typeID = 2311;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10043, 'Suspended Plasma', '96_03');
UPDATE invTypes SET graphicID = 10043 WHERE typeID = 2308;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10044, 'Autotrophs', '97_12');
UPDATE invTypes SET graphicID = 10044 WHERE typeID = 2305;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10045, 'Carbon Compounds', '97_11');
UPDATE invTypes SET graphicID = 10045 WHERE typeID = 2288;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10046, 'Complex Organisms', '97_10');
UPDATE invTypes SET graphicID = 10046 WHERE typeID = 2287;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10047, 'Micro Organisms', '97_08');
UPDATE invTypes SET graphicID = 10047 WHERE typeID = 2073;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10048, 'Planktic Colonies', '97_09');
UPDATE invTypes SET graphicID = 10048 WHERE typeID = 2286;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10049, 'Felsic Magma', '97_02');
UPDATE invTypes SET graphicID = 10049 WHERE typeID = 2307;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10050, 'Non-CS Crystals', '97_01');
UPDATE invTypes SET graphicID = 10050 WHERE typeID = 2306;

-- wrong icons:
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10051, 'Biomass', '97_04');
UPDATE invTypes SET graphicID = 10051 WHERE typeID = 3779;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10052, 'Aqueous Liquids', '96_02');
UPDATE invTypes SET graphicID = 10052 WHERE typeID = 2268;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10053, 'Base Metals', '96_14');
UPDATE invTypes SET graphicID = 10053 WHERE typeID = 2267;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10054, 'Heavy Metals', '96_16');
UPDATE invTypes SET graphicID = 10054 WHERE typeID = 2272;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10055, 'Noble Metals', '96_15');
UPDATE invTypes SET graphicID = 10055 WHERE typeID = 2270;
INSERT INTO eveGraphics (graphicID, description, icon) VALUES (10056, 'Nanites', '98_11');
UPDATE invTypes SET graphicID = 10056 WHERE typeID = 2463;
-- missing cargo icon
